/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package queenb.web.store;

import java.sql.SQLException;
import java.util.Date;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import oracle.jdbc.OracleTypes;

import queenb.net.datacontrol.DataStatement;
import queenb.net.datacontrol.Param;
import queenb.net.entitybean.N420;
import queenb.web.util.PackageContants;


/**
 *
 * @author Ka
 */
public class N420Store extends N420{
    
    public List<N420> getListN420(int fh000, int fh200, Date nd401, int  fc250, int fn850, String login )
    {
        try {
            DataStatement updateStatement = new DataStatement(PackageContants.LIST_N420, OracleTypes.CURSOR, new Param[]{
                        new Param(OracleTypes.INTEGER, fh000),
                        new Param(OracleTypes.INTEGER, fh200),
                        new Param(OracleTypes.DATE, nd401),
                        new Param(OracleTypes.INTEGER, fc250),
                        new Param(OracleTypes.INTEGER, fn850),
                        new Param(OracleTypes.CHAR, login)});
            return super.find(updateStatement, N420.class);
        } catch (Exception ex) {
            Logger.getLogger(N420Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }
    
    public int updateN420()
    {
        return 0;
    }
    
}
